package com.new2i.dao.mapper;

import java.util.HashMap;
import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.new2i.model.ScreenQuarterEntity;

/**
 * 筛查季度ORM mapper
 * 
 * @author 2i
 * @since 2015/09/24
 *
 */
public interface ScreenQuarterMapper {

	/**
	 * 创建筛查季度
	 * 
	 * @author 2i
	 * @since 2015/09/22
	 * @param scDoctor
	 * @return
	 */
	Integer insertScreenQuarter(ScreenQuarterEntity scQuarter); 

	/**
	 * 根据创建医生的id获取其所有的筛查季度
	 * 
	 * @author 2i
	 * @since 2015/09/2
	 * @param tel
	 * @param doctor_id
	 * @return
	 */
	List<HashMap<String, Object>> selectScreenQuarterList(@Param("doctor_id") final Integer doctor_id,
			@Param("start") final Integer start, @Param("offset") final Integer offset);
 
	/**
	 * 通过id查询季度的详细信息
	 * 
	 * @author 2i
	 * @since 2015/09/22
	 * @param tel
	 * @return
	 */
	HashMap<String, Object> getScreenQuarterById(@Param("sc_quarter_id") final Integer sc_quarter_id);
 
	
	/**
	 * 修改筛查季度的登录密码
	 * 
	 * @author 2i
	 * @since 2015/09/24
	 * @param scQuarter 
	 * @return
	 */
	Integer updateScreenQuarter(ScreenQuarterEntity scQuarter);
	  
	/**
	 * 移除（软删除）筛查季度
	 * 
	 * @author 2i
	 * @since 2015/09/24
	 * @param sc_quarter_id
	 * @param doctor_id
	 * @return
	 */
	Integer removeScreenQuarter(@Param("sc_quarter_id") final Integer sc_quarter_id,
			@Param("doctor_id") final Integer doctor_id);
	

	/**
	 * 还原筛查季度
	 * 
	 * @author 2i
	 * @since 2015/09/24
	 * @param sc_quarter_id
	 * @param doctor_id
	 * @return
	 */
	Integer backupScreenQuarter(@Param("sc_quarter_id") final Integer sc_quarter_id,
			@Param("doctor_id") final Integer doctor_id);
	
	/**
	 * 删除筛查季度
	 * 
	 * @author 2i
	 * @since 2015/09/24
	 * @param sc_quarter_id
	 * @param doctor_id
	 * @return
	 */
	Integer deleteScreenQuarter(@Param("sc_quarter_id") final Integer sc_quarter_id,
			@Param("doctor_id") final Integer doctor_id);
}
